The compatibility setting also determines the keywords that are reserved by the database engine 兼容性设置还确定了数据库引擎所保留的关键字。
When the compatibility setting of a database is changed , all of its stored procedures are automatically recompiled accordingly . environmental considerations for using sp dbcmptlevel 在更改某一数据库的兼容性设置时,该数据库的所有存储过程都将随之自动重新编译。
The new compatibility setting for a database takes effect when the database is next made current whether as the default database on login or on being specified in a use statement 数据库的新兼容性设置将在该数据库下次成为当前数据库(无论是在登录时作为默认数据库还是在use语句中指定)时生效。